Error: Cannot close...due to Excel module sheets cannot be displayed in Binder.

Error:

Cannot close with a module active. Please switch to another sheet in the workbook.

Cause:

View Outside has been selected to view a module sheet in a binder that contains only Excel module sheets. This will open Excel and the error message occurs when trying to exit Excel and return to the binder. Module sheets cannot be displayed in a Binder.

Solution:

Select 'Worksheet' or 'Chart' from the 'Insert' menu to add a worksheet or chart sheet to the binder and make it active before exiting Excel.